Skip to main content
Announcements
Qlik Introduces a New Era of Visualization! READ ALL ABOUT IT
cancel
Showing results for 
Search instead for 
Did you mean: 
israrkhan
Specialist II
Specialist II

Qlikview Syntax

Hi Community,

Any Body would like to explane me the syntax below,

i am confuse with some statment. confusion marked in red color.

1) sum({[GROUP 1]<Region = $ :: Region >} sales)... why to use double colon :: in set analysis.

2) sum(sales)/ sum(total < Month, Group > sales )... why to use < > here.

3) sum({<year= {$ (# vLastyear)} sales)..why to use # with variable.

your explanation would be highly appreacited...

kind Regards

Khan

1 Solution

Accepted Solutions
jagan
Luminary Alumni
Luminary Alumni

Hi,

1) :: represents Alternate states, Group1 alternate state is equating with default state Region values.

2) If you want to group by dimensions then you can specify like this total < Month, Group >, groups the sales value by Month and Group.

3) Here # represents number, it is not mandatory.

Regards,

Jagan.

View solution in original post

3 Replies
jagan
Luminary Alumni
Luminary Alumni

Hi,

1) :: represents Alternate states, Group1 alternate state is equating with default state Region values.

2) If you want to group by dimensions then you can specify like this total < Month, Group >, groups the sales value by Month and Group.

3) Here # represents number, it is not mandatory.

Regards,

Jagan.

kuba_michalik
Partner - Specialist
Partner - Specialist

I don't want to sound dismissive, but you can find all of that in Reference Guide, and I honestly doubt my own explanation would be better in any way 😉 Specifically:

1) page 844, Alternate States in Set Expressions

2) page 782, Chart Aggregation Functions (examples on page 843)

3) page 281, Dollar-Sign Expansion Using a Variable

(page numbers from Reference Guide for QlikView 11 SR2, 11414)

alexdataiq
Partner - Creator III
Partner - Creator III

Thank you. It pointed me out to the according sections in the Reference Manual!