How to create AND Mode ?

[paulyeo11]

Hi All

I have read the blog post today by jennell :-

http://community.qlik.com/blogs/qlikviewdesignblog

In her example , the data model break into make part , sales detail , customer , items master. for mine is very simple , in one flat table.

Hope some one can share with how to generate AND_Mode_field ? using my example.

[paulyeo11]

Enclosed my QV doc

[nizamsha]

refer this link

http://community.qlik.com/blogs/qlikviewdesignblog/2013/07/19/and-mode

[er_mohit · Accepted solution]

Try this

[#5]

see link

http://community.qlik.com/blogs/qlikviewdesignblog/2013/07/19/and-mode

for example see attached file

[paulyeo11]

Hi All

Many thank for all your reply.

i hv refer to both your QC doc , i think the track is last few line of the script.

still need to figure out.

[paulyeo11]

Hi All

After i convert the raw data to fruit , now i understand how the AND mode work. , many thank.